package com.shuma.product.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.github.pagehelper.Page;
import com.shuma.product.pojo.GoodsBaseInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.time.LocalDateTime;

/**
 * @author 23083
 * @description 针对表【goods_base_info】的数据库操作Mapper
 * @createDate 2024-06-16 21:13:27
 * @Entity generator.domain.BaseGoods
 */
@Repository
@Mapper
public interface GoodsBaseInfoMapper extends BaseMapper<GoodsBaseInfo> {
    public Page<GoodsBaseInfo> getByoperatoridhavetime(@Param("operatorid") Long id,
                                                       @Param("goodsonlinestatus")Long goodsonlinestatus,
                                                       @Param("goodsbaseid")Long goodsbaseid,
                                                       @Param("goodsname")String goodsname,
                                                       @Param("onlinetime")LocalDateTime onlinetime,
                                                       @Param("expiretime")LocalDateTime expiretime,
                                                       @Param("operatorname")String operatorname);
    public Page<GoodsBaseInfo> getByoperatoridnohavetime(@Param("operatorid") Long id,
                                                         @Param("goodsonlinestatus")Long goodsonlinestatus,
                                                         @Param("goodsbaseid")Long goodsbaseid,
                                                         @Param("goodsname")String goodsname,
                                                         @Param("operatorname")String operatorname);
    public GoodsBaseInfo getBygoodsbaseid(@Param("goodsbaseid") Long id);
    public Page<GoodsBaseInfo> getAllgoodsbasehavetime(@Param("goodsonlinestatus")Long goodsonlinestatus,
                                                       @Param("goodsbaseid")Long goodsbaseid,
                                                       @Param("goodsname")String goodsname,
                                                       @Param("onlinetime")LocalDateTime onlinetime,
                                                       @Param("expiretime")LocalDateTime expiretime,
                                                       @Param("operatorname")String operatorname);
    public Page<GoodsBaseInfo> getAllgoodsbasenohavetime(@Param("goodsonlinestatus")Long goodsonlinestatus,
                                                         @Param("goodsbaseid")Long goodsbaseid,
                                                         @Param("goodsname")String goodsname,
                                                         @Param("operatorname")String operatorname);
}




